FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > NamedStyleCollection Class > AddRange Method : AddRange(NamedStyle[]) Method |
'Declaration Public Overloads Overridable Sub AddRange( _ ByVal array() As NamedStyle _ )
'Usage Dim instance As NamedStyleCollection Dim array() As NamedStyle instance.AddRange(array)
public virtual void AddRange( NamedStyle[] array )
FarPoint.Web.Spread.NamedStyleCollection nsc = new FarPoint.Web.Spread.NamedStyleCollection(); FarPoint.Web.Spread.NamedStyle ns = new FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault"); FarPoint.Web.Spread.NamedStyle ns1 = new FarPoint.Web.Spread.NamedStyle("HeaderData", "HeaderDefault"); System.Collections.ArrayList c = new System.Collections.ArrayList(2); ns.BackColor = Color.Yellow; ns.Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Blue); ns1.BackColor = Color.Teal; ns1.Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Red); c.Add(ns); c.Add(ns1); nsc.AddRange(c); FpSpread1.NamedStyles.AddRange(new Object[] {nsc[0], nsc[1]}); FpSpread1.ActiveSheetView.DefaultStyle = nsc[0]; FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = nsc[1];
Dim nsc As New FarPoint.Web.Spread.NamedStyleCollection Dim ns As New FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault") Dim ns1 As New FarPoint.Web.Spread.NamedStyle("HeaderData", "HeaderDefault") Dim c As New System.Collections.ArrayList(2) ns.BackColor = Color.Yellow ns.Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Blue) ns1.BackColor = Color.Teal ns1.Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Red) c.Add(ns) c.Add(ns1) nsc.AddRange(c) FpSpread1.NamedStyles.AddRange(New Object() {nsc(0), nsc(1)}) FpSpread1.ActiveSheetView.DefaultStyle = nsc(0) FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = nsc(1)
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6